/****** Object:  View [dbo].[Products Above Average Price]    Script Date: 06/12/2011 01:42:52 ******/
DROP VIEW [dbo].[Products Above Average Price]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create view [dbo].[Products Above Average Price] AS
SELECT Products.ProductName, Products.UnitPrice
FROM Products
WHERE Products.UnitPrice>(SELECT AVG(UnitPrice) From Products)
--ORDER BY Products.UnitPrice DESC
GO
